Tabela LExternalOrgUnitAddress

Definicja tabeli LExternalOrgUnitAddress

Name

LExternalOrgUnitAddress

Code

LExternalOrgUnitAddress

Comment

PL: Polaczenie placówki zewnetrznej z adresem
EN: Link between external organization unit and address


Lista kolumn tabeli LExternalOrgUnitAddress

Name

Code

ExternalOrgUnitID

ExternalOrgUnitID

AddressID

AddressID

StartDT

StartDT

StopDT

StopDT


Kolumna ExternalOrgUnitID tabeli LExternalOrgUnitAddress

Definicja kolumny ExternalOrgUnitID tabeli LExternalOrgUnitAddress

Name

ExternalOrgUnitID

Code

ExternalOrgUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AddressID tabeli LExternalOrgUnitAddress

Definicja kolumny AddressID tabeli LExternalOrgUnitAddress

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

PL: Klucz glówny tabeli
EN: Primary key of the table
DE: Der Schlüssel der Tabelle


Kolumna StartDT tabeli LExternalOrgUnitAddress

Definicja kolumny StartDT tabeli LExternalOrgUnitAddress

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LExternalOrgUnitAddress

Definicja kolumny StopDT tabeli LExternalOrgUnitAddress

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli LExternalOrgUnitAddress

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LExternalOrgUnitAddress

Definicja klucza Identifier_1 tabeli LExternalOrgUnitAddress

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment